Understanding subqueries in SQL Server

join shbcf.ru